forum

home / developersection / forums / how to create a procedure for delete record by id ?

Ask Question
Anonymous User

A_Philosopher

I am a content writter !

Message
Can you answer this question?
Answer

1 Answers

Anonymous User

Anonymous User

31-Jul-2018 
//----------Delete Record By ID---------//

CREATE PROC ContactDeleteByID

@ContactID int

AS

Begin

 Select * from Contact

 where ContactID=@ContactID

END
NOTE:-
1). Don’t make space between parameter name Like :
Student Name -------- (wrong syntax).
Student_Name or StudentName -------- (Correct Syntex).
2). When You need to update Stored Procedure then you use ALTER keyword place on CREATE.
And execute procedure after the update.

advertising
advertising

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy